Create Line and Clustered Chart for Total Accidents by Weather Conditions 16
To create Create Line and Clustered Chart for Total Accidents by Weather Conditions please follow the steps below.
Step 1: Weather condition dimension has a lot of values. So the first step here is to group Weather conditions into similar values. On the US_Accidents_Dec20 table, right click on Weather_Condition, then click on New Group. Using the table below as a guide, select the Ungrouped values, click 'Group', then give a name to the Group. (See GIF below)
Note:
Step 2: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. Drag and drop %HighSeverity to the Tooltips. In the US_Accidents_Dec20 table, click on 'Weather_Condition (Groups)' and 'Weather_Condition' to add to the Shared axis. (See screenshot below)
Step 3: Format chart using screenshots and GIF below as a guide.
I. General
II. X Axis, Y Axis
III. Data colors
III. Data labels, Shapes, Background and Shadow
IV. Title text
Step 4: Save your report 'Ctrl + S'
For tips on how to create and use combo chart in Power BI, visit: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
For tips on how to Use grouping and binning in Power BI Desktop, visit: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning